This model dimension represents the Serial Structure Information, part of Vehicle Information Management, and is based on the IFS Cloud dimension DIM_VIM_SERIAL. All models that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Description (where applicable) |
Eng Part Revision | Part revision for the serial |
Location Code | Location Code for the serial |
Maint Group | Maint Group Code |
Maint Group Desc | Maint Group Description |
Maint Prog Id | Risk Consequence ID - Consequence Description |
Maint Prog Rev | Maint Prog Revision No |
Manufactured Date | Article Manufacturing Date |
Manufacturer | |
Manufacturer Name | |
Manufacturer Part No | Manufacturer's article number |
Operational Condition | Operational Condition |
Operational Status | Operational Status |
Owner Desc | Owner Organization Description |
Owner Org | Owner Organization Code |
Owning Customer No | Owning Customer Code |
Part Desc | Part Description |
Part No | Part Number |
Part Ownership | Type of ownership description |
Quarantined | Quarantined TRUE/FALSE |
Serial No | Part Serial Number |
Structure Address | Structure Position Address |
Template Part No | Template Part Number |
Template Part Rev | Template Part Revision Number |
Vehicle Id | Vehicle Id |
VIM Serial | Partno + Serial No +Part Description |
Workshop Code | Workshop Code |
Model Name |
Maintenance |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
VIM SERIAL | DIM_VIM_SERIAL_TM | DIM_VIM_SERIAL_BI | DIM_VIM_SERIAL | On Line |